Dan W
Dan W
Reactions
-
Re: The dreaded #invalid data type
IFERROR. Toss that in the front and the value you want if an error occurs at the end. I just put 0. You could put "" to leave it blank =IFERROR(IF(MONTH([start date]@row) = 1, "January…1 · -
Re: Adding values contingent on a multiselect dropdown
You will want to remove the numbers at the end of your [Selection Values]:[Selection Values] and [Selection Items]:[Selection Items]. That way it will search the whole column not just 1-3 =SUMIFS([Se…1 · -
Re: Adding values contingent on a multiselect dropdown
So I had a similar problem, here is the solution I came up with. I had a separate resource sheet that had the values of each Resource that could be selected in the drop down. Then I referenced that s…2 · -
Re: SUM formula
Here is an alternate way to use. Your original function was working for me. Hope this helps!1 ·
